package edu.njust.dao;

import edu.njust.domain.Consumer;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.web.bind.annotation.PathVariable;

import java.util.Date;
import java.util.List;

@Mapper
public interface ConsumerMapper {
    //删除消费者
    public int deleteById(int id);
    //插入
    public int insertAll(Consumer consumer);
//给修改用的查询
    public	Consumer selectById(int id,String pwd);
    //修改
    public int updateById(Consumer consumer);
    //3、修改密码
    public int updatePwdById(int id, String pwd);
    //分页模糊查询
    public List<Consumer> pageSelect(@Param("name")String name, @Param("start")int start, @Param("pageSize")int pageSize);
    //分页模糊查询总条数
    public int countSelect(@Param("name")String name);
    //ajax 验证是否存在 此身份证号码
    public int selectYZ(String papersNumber);
}
